Ordering the Joins

The order of your table joins can impact performance substantially. Although the optimal order depends on the report, the key iMIS joins are:

Name.ID = Activity.ID

Name.ID = Subscription.ID

Name.ID = Invoice.BT_ID

Orders.ORDER_NUMBER = Order_Lines.ORDER_NUMBER

Product.PRODUCT_CODE = Order_Lines.PRODUCT_CODE

Name.ID = Orders.BT_ID